package cn.com.api.mapper.base;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.*;

import cn.com.api.entity.ApiT_shops_apply;

//DAO
public interface T_shops_applyMapperBase {

	//根据id查看
    @Select("SELECT * FROM t_shops_apply  WHERE id = #{id}")
	public ApiT_shops_apply findT_shops_applyById(Integer id);
	
    //查看数据集
    @Select("SELECT * FROM T_shops_apply")
	public List<ApiT_shops_apply> findT_shops_applys();
	
	//添加
    @Insert("INSERT INTO t_shops_apply (shop_id, shop_name, shop_type, day_avg_money, sign_time, create_time, money, bd_user, status, remark) VALUES (#{shop_id}, #{shop_name}, #{shop_type}, #{day_avg_money}, #{sign_time}, #{create_time}, #{money}, #{bd_user}, #{status}, #{remark})")
 	@Options(useGeneratedKeys = true, keyProperty = "id")
    public int insertT_shops_apply(ApiT_shops_apply t_shops_apply);
  	
	//修改
    @Update("UPDATE t_shops_apply SET shop_id = #{shop_id}, shop_name = #{shop_name}, shop_type = #{shop_type}, day_avg_money = #{day_avg_money}, sign_time = #{sign_time}, create_time = #{create_time}, money = #{money}, bd_user = #{bd_user}, status = #{status}, remark = #{remark} WHERE id = #{id}")
    public int updateT_shops_apply(ApiT_shops_apply t_shops_apply);
    
    //删除
    @Delete("DELETE FROM t_shops_apply  WHERE id = #{id}")
    public int deleteT_shops_apply(Integer id);
 
    // Foreign keys revelant		
		

	//region Indexs revelant
    
    
    
}


